Problem Note 36414: "Value was either too large or too small for Int32" error in the SAS® Add-In for Microsoft Office
When you open and filter a table that exceeds 2,147,483,647 rows in Microsoft Excel using the SAS Add-in for Microsoft Office, you might receive the following error when opening the table or previewing the table:
Value was either too large or too small for Int32
System.OverflowException: Int32
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo
info)
at SAS.Servers.Dataset.GetTotalRowCount()
at SAS.Servers.DatasetPreviewPane.UpdateRecordCounts()
at SAS.Servers.DatasetPreviewPane.FillInDataList()
at SAS.Servers.DatasetPreviewPane.m_btnUpdate_Click(Object sender, EventArgs
e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button,
Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr
wparam, IntPtr lparam)
To circumvent this problem, subset your data so that it returns fewer than 2 billion rows of data.
Operating System and Release Information
| SAS System | SAS Add-in for Microsoft Office | Microsoft Windows 95/98 | 2.1 | | | |
| Microsoft Windows 2000 Advanced Server | 2.1 | | | |
| Microsoft Windows 2000 Datacenter Server | 2.1 | | | |
| Microsoft Windows 2000 Server | 2.1 | | | |
| Microsoft Windows 2000 Professional | 2.1 | | | |
| Microsoft Windows NT Workstation | 2.1 | | | |
| Microsoft Windows Server 2003 Datacenter Edition | 2.1 | 4.3 | | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 2.1 | 4.3 | | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Standard Edition | 2.1 | 4.3 | | 9.2 TS2M0 |
| Microsoft Windows Server 2008 | 2.1 | | | |
| Microsoft Windows XP Professional | 2.1 | 4.3 | | 9.2 TS2M0 |
| Windows Millennium Edition (Me) | 2.1 | | | |
| Windows Vista | 2.1 | 4.3 | | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Third Party ==> Products ==> Microsoft Office
|
| Date Modified: | 2009-07-05 17:59:46 |
| Date Created: | 2009-06-30 12:47:36 |
